﻿IF OBJECT_ID ('dbo.CHO_TASKS') IS NOT NULL
	DROP TABLE dbo.CHO_TASKS
GO

IF OBJECT_ID ('dbo.CHO_TASKS_AUDIT') IS NOT NULL
	DROP TABLE dbo.CHO_TASKS_AUDIT
GO

IF OBJECT_ID ('dbo.CHO_ADD_OR_UPDATE_TASK') IS NOT NULL
	DROP PROC dbo.CHO_ADD_OR_UPDATE_TASK
GO

IF OBJECT_ID ('dbo.CHO_DELETE_TASK') IS NOT NULL
	DROP PROC dbo.CHO_DELETE_TASK
GO

IF OBJECT_ID ('dbo.CHO_SELECT_TASKS_UI') IS NOT NULL
	DROP PROC dbo.CHO_SELECT_TASKS_UI
GO

IF OBJECT_ID ('dbo.CHO_SELECT_TASKS') IS NOT NULL
	DROP PROC dbo.CHO_SELECT_TASKS
GO

IF OBJECT_ID ('dbo.CHO_SELECT_DEPENDENCY_TASKS') IS NOT NULL
	DROP PROC dbo.CHO_SELECT_DEPENDENCY_TASKS
GO

IF OBJECT_ID ('dbo.CHO_IS_TASK_EXISTS') IS NOT NULL
	DROP PROC dbo.CHO_IS_TASK_EXISTS
GO

IF OBJECT_ID ('dbo.CHO_UNDELETE_TASK') IS NOT NULL
	DROP PROC dbo.CHO_UNDELETE_TASK
GO

IF OBJECT_ID ('dbo.CHO_CLONE_TASK_DEFINITION') IS NOT NULL
	DROP PROC dbo.CHO_CLONE_TASK_DEFINITION
GO
